﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;

using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;

using System.Data.OleDb;

public partial class show : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        int ID = (Request.QueryString["ID"]==null) ? 1 : int.Parse(Request.QueryString["ID"]);
        OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\air\Desktop\ASP.net\App_Data\MainDB.mdb;Persist Security Info=True");
        OleDbCommand mycomm = new OleDbCommand("SELECT * FROM [Species] WHERE ID="+ID, conn);
        conn.Open();
        OleDbDataReader rs = mycomm.ExecuteReader();
        rs.Read();
        for (int i = 0; i < 10;i++ )
            Response.Write(rs[i] + "<br />");
        rs.Close();
        conn.Close();
    }
}
